/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.1.53-3308
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : 192.168.1.53:3308
 Source Schema         : yygh_manage

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 09/11/2022 10:45:23
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hospital_set
-- ----------------------------
DROP TABLE IF EXISTS `hospital_set`;
CREATE TABLE `hospital_set` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `hoscode` varchar(30) DEFAULT NULL COMMENT '医院编号',
  `sign_key` varchar(50) DEFAULT NULL COMMENT '签名秘钥',
  `api_url` varchar(100) DEFAULT NULL COMMENT '统一挂号平台api地址',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COMMENT='医院设置表';

-- ----------------------------
-- Records of hospital_set
-- ----------------------------
BEGIN;
INSERT INTO `hospital_set` (`id`, `hoscode`, `sign_key`, `api_url`, `create_time`, `update_time`, `is_deleted`) VALUES (1, '1000_0', 'ba27058f8dcbf42c1523b4b7881a1c07', 'http://localhost', '2022-11-02 06:14:55', '2022-11-04 06:08:03', 0);
COMMIT;

-- ----------------------------
-- Table structure for order_info
-- ----------------------------
DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `schedule_id` bigint DEFAULT NULL COMMENT '排班id',
  `patient_id` bigint DEFAULT NULL COMMENT '就诊人id',
  `number` int DEFAULT NULL COMMENT '预约号序',
  `fetch_time` varchar(50) DEFAULT NULL COMMENT '建议取号时间',
  `fetch_address` varchar(255) DEFAULT NULL COMMENT '取号地点',
  `amount` decimal(10,0) DEFAULT NULL COMMENT '医事服务费',
  `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
  `quit_time` datetime DEFAULT NULL COMMENT '退号时间',
  `order_status` tinyint DEFAULT NULL COMMENT '订单状态',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb3 COMMENT='订单表';

-- ----------------------------
-- Records of order_info
-- ----------------------------
BEGIN;
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (13, 1, 1, 14, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-04 07:32:43', '2022-11-04 07:32:43', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (14, 1, 1, 15, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-04 07:35:53', '2022-11-04 07:35:53', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (15, 1, 1, 16, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-04 07:55:50', '2022-11-04 07:55:50', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (16, 1, 1, 17, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-04 08:37:28', '2022-11-04 08:37:28', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (17, 1, 1, 18, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-04 08:37:54', '2022-11-04 08:37:54', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (18, 1, 1, 19, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-04 08:41:07', '2022-11-04 08:41:07', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (19, 1, 1, 20, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-04 08:45:28', '2022-11-04 08:45:28', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (20, 1, 1, 21, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-04 08:46:52', '2022-11-04 08:46:52', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (21, 1, 1, 22, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-06 10:25:54', '2022-11-06 10:25:54', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (22, 1, 1, 23, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-06 10:48:55', '2022-11-06 10:48:55', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (23, 1, 1, 24, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-06 10:59:49', '2022-11-06 10:59:49', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (24, 1, 1, 25, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-06 11:09:14', '2022-11-06 11:09:14', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (25, 1, 1, 26, '0 14:00前', '一楼9号窗口', 100, NULL, NULL, 0, '2022-11-06 11:11:56', '2022-11-06 11:11:56', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (26, 1, 1, 27, '0 14:00前', '一楼9号窗口', 100, '2022-11-06 19:44:36', '2022-11-08 11:41:20', -1, '2022-11-06 11:29:21', '2022-11-06 11:29:21', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (27, 1, 1, 28, '0 14:00前', '一楼9号窗口', 100, '2022-11-06 19:46:08', '2022-11-08 10:54:47', -1, '2022-11-06 11:41:46', '2022-11-06 11:41:46', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (28, 1, 1, 29, '0 14:00前', '一楼9号窗口', 100, '2022-11-06 19:45:20', '2022-11-08 10:45:58', -1, '2022-11-06 11:45:00', '2022-11-06 11:45:00', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (29, 1, 1, 30, '0 14:00前', '一楼9号窗口', 100, NULL, '2022-11-08 12:12:38', -1, '2022-11-08 03:41:42', '2022-11-08 03:41:42', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (30, 1, 1, 31, '1 14:00前', '一楼9号窗口', 100, NULL, '2022-11-08 12:52:34', -1, '2022-11-08 04:52:19', '2022-11-08 04:52:19', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (31, 1, 1, 32, '1 14:00前', '一楼9号窗口', 100, '2022-11-08 12:53:55', '2022-11-08 12:55:10', -1, '2022-11-08 04:53:31', '2022-11-08 04:53:31', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (32, 1, 1, -6, '0 14:00前', '一楼9号窗口', 100, NULL, '2022-11-08 19:46:49', -1, '2022-11-08 11:45:29', '2022-11-08 11:45:29', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (33, 1, 1, -5, '0 14:00前', '一楼9号窗口', 100, '2022-11-08 19:48:26', '2022-11-08 19:56:44', -1, '2022-11-08 11:47:42', '2022-11-08 11:47:42', 0);
INSERT INTO `order_info` (`id`, `schedule_id`, `patient_id`, `number`, `fetch_time`, `fetch_address`, `amount`, `pay_time`, `quit_time`, `order_status`, `create_time`, `update_time`, `is_deleted`) VALUES (34, 1, 1, -4, '0 14:00前', '一楼9号窗口', 100, '2022-11-09 09:14:43', NULL, 1, '2022-11-09 01:03:24', '2022-11-09 01:03:24', 0);
COMMIT;

-- ----------------------------
-- Table structure for schedule
-- ----------------------------
DROP TABLE IF EXISTS `schedule`;
CREATE TABLE `schedule` (
  `id` bigint NOT NULL DEFAULT '0' COMMENT '编号',
  `hoscode` varchar(30) DEFAULT NULL COMMENT '医院编号',
  `depcode` varchar(30) DEFAULT NULL COMMENT '科室编号',
  `title` varchar(20) DEFAULT NULL COMMENT '职称',
  `docname` varchar(20) DEFAULT NULL COMMENT '医生名称',
  `skill` text COMMENT '擅长技能',
  `work_date` date DEFAULT NULL COMMENT '安排日期',
  `work_time` tinyint DEFAULT '0' COMMENT '安排时间（0：上午 1：下午）',
  `reserved_number` int DEFAULT '0' COMMENT '可预约数',
  `available_number` int DEFAULT '0' COMMENT '剩余预约数',
  `amount` decimal(10,0) DEFAULT NULL COMMENT '挂号费',
  `status` tinyint DEFAULT NULL COMMENT '排班状态（-1：停诊 0：停约 1：可约）',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='医生日程安排表';

-- ----------------------------
-- Records of schedule
-- ----------------------------
BEGIN;
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (1, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-13', 0, 33, 37, 100, 1, '2022-11-03 09:56:03', '2022-11-08 11:45:23', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (2, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-22', 0, 40, 6, 100, 1, '2022-11-03 09:56:07', '2022-11-03 09:56:07', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (3, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-22', 1, 27, 10, 100, 1, '2022-11-03 09:56:11', '2022-11-03 09:56:11', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (4, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-14', 0, 33, 22, 100, 1, '2022-11-03 09:56:15', '2022-11-03 09:56:15', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (5, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-23', 0, 40, 6, 100, 1, '2022-11-03 09:56:19', '2022-11-03 09:56:19', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (6, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-23', 1, 27, 10, 100, 1, '2022-11-03 09:56:24', '2022-11-03 09:56:24', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (7, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-15', 0, 33, 22, 100, 1, '2022-11-03 09:56:27', '2022-11-03 09:56:27', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (8, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-24', 0, 40, 6, 100, 1, '2022-11-03 09:56:30', '2022-11-03 09:56:30', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (9, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-24', 1, 27, 10, 100, 1, '2022-11-03 09:56:34', '2022-11-03 09:56:34', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (10, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-16', 0, 33, 22, 100, 1, '2022-11-03 09:56:38', '2022-11-03 09:56:38', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (11, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-25', 0, 40, 6, 100, 1, '2022-11-03 09:56:41', '2022-11-03 09:56:41', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (12, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-25', 1, 27, 10, 100, 1, '2022-11-03 09:56:44', '2022-11-03 09:56:44', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (13, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-17', 0, 33, 22, 100, 1, '2022-11-03 09:56:48', '2022-11-03 09:56:48', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (14, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-26', 0, 40, 6, 100, 1, '2022-11-03 09:56:51', '2022-11-03 09:56:51', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (15, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-26', 1, 27, 10, 100, 1, '2022-11-03 09:56:54', '2022-11-03 09:56:54', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (16, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-18', 0, 33, 22, 100, 1, '2022-11-03 09:56:57', '2022-11-03 09:56:57', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (17, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-27', 0, 40, 6, 100, 1, '2022-11-03 09:57:00', '2022-11-03 09:57:00', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (18, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-27', 1, 27, 10, 100, 1, '2022-11-03 09:57:03', '2022-11-03 09:57:03', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (19, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-19', 0, 33, 22, 100, 1, '2022-11-03 09:57:07', '2022-11-03 09:57:07', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (20, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-28', 0, 40, 6, 100, 1, '2022-11-03 09:57:10', '2022-11-03 09:57:10', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (21, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-28', 1, 27, 10, 100, 1, '2022-11-03 09:57:13', '2022-11-03 09:57:13', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (22, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-20', 0, 33, 22, 100, 1, '2022-11-03 09:57:16', '2022-11-03 09:57:16', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (23, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-29', 0, 40, 6, 100, 1, '2022-11-03 09:57:18', '2022-11-03 09:57:18', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (24, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-29', 1, 27, 10, 100, 1, '2022-11-03 09:57:20', '2022-11-03 09:57:20', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (25, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-21', 0, 33, 22, 100, 1, '2022-11-03 09:57:23', '2022-11-03 09:57:23', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (26, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-30', 0, 40, 6, 100, 1, '2022-11-03 09:57:26', '2022-11-03 09:57:26', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (27, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-30', 1, 27, 10, 100, 1, '2022-11-03 09:57:30', '2022-11-03 09:57:30', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (29, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-30', 0, 40, 6, 100, 1, '2022-11-03 09:57:34', '2022-11-03 09:57:34', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (30, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-30', 1, 27, 10, 100, 1, '2022-11-03 09:57:37', '2022-11-03 09:57:37', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (31, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-01', 0, 33, 22, 100, 1, '2022-11-03 09:57:39', '2022-11-03 09:57:39', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (32, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-01', 0, 40, 6, 100, 1, '2022-11-03 09:57:41', '2022-11-03 09:57:41', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (33, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-01', 1, 27, 10, 100, 1, '2022-11-03 09:57:45', '2022-11-03 09:57:45', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (34, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2021-01-02', 0, 33, 22, 100, 1, '2022-11-03 09:57:49', '2022-11-03 09:57:49', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (35, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-02', 0, 40, 6, 100, 1, '2022-11-03 09:57:55', '2022-11-03 09:57:55', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (36, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-02', 1, 27, 10, 100, 1, '2022-11-03 09:58:00', '2022-11-03 09:58:00', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (37, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2021-01-03', 0, 33, 22, 100, 1, '2022-11-03 09:58:04', '2022-11-03 09:58:04', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (38, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-03', 0, 40, 6, 100, 1, '2022-11-03 09:58:05', '2022-11-03 09:58:05', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (39, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-03', 1, 27, 10, 100, 1, '2022-11-03 09:58:07', '2022-11-03 09:58:07', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (40, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2021-01-04', 0, 33, 22, 100, 1, '2022-11-03 09:58:08', '2022-11-03 09:58:08', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (41, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-04', 0, 40, 6, 100, 1, '2022-11-03 09:58:09', '2022-11-03 09:58:09', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (42, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-04', 1, 27, 10, 100, 1, '2022-11-03 09:58:11', '2022-11-03 09:58:11', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (43, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2021-01-05', 0, 33, 22, 100, 1, '2022-11-03 09:58:13', '2022-11-03 09:58:13', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (44, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-05', 0, 40, 6, 100, 1, '2022-11-03 09:58:14', '2022-11-03 09:58:14', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (45, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-05', 1, 27, 10, 100, 1, '2022-11-03 09:58:16', '2022-11-03 09:58:16', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (46, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2021-01-06', 0, 33, 22, 100, 1, '2022-11-03 09:58:17', '2022-11-03 09:58:17', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (47, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-06', 0, 40, 6, 100, 1, '2022-11-03 09:58:18', '2022-11-03 09:58:18', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (48, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-06', 1, 27, 10, 100, 1, '2022-11-03 09:58:20', '2022-11-03 09:58:20', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (49, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-07', 0, 33, 22, 100, 1, '2022-11-03 09:58:23', '2022-11-03 09:58:23', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (50, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-07', 0, 40, 6, 100, 1, '2022-11-03 09:58:32', '2022-11-03 09:58:32', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (51, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-07', 1, 27, 10, 100, 1, '2022-11-03 09:58:50', '2022-11-03 09:58:50', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (52, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-08', 0, 33, 22, 100, 1, '2022-11-03 09:59:10', '2022-11-03 09:59:10', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (53, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-08', 0, 40, 6, 100, 1, '2022-11-03 09:59:27', '2022-11-03 09:59:27', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (54, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-08', 1, 27, 10, 100, 1, '2022-11-03 09:59:37', '2022-11-03 09:59:37', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (55, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-09', 0, 33, 22, 100, 1, '2022-11-03 09:59:43', '2022-11-03 09:59:43', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (56, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-09', 0, 40, 6, 100, 1, '2022-11-03 09:59:50', '2022-11-03 09:59:50', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (57, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-09', 1, 27, 10, 100, 1, '2022-11-03 09:59:59', '2022-11-03 09:59:59', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (58, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-10', 0, 33, 22, 100, 1, '2022-11-03 10:00:05', '2022-11-03 10:00:05', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (59, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-10', 0, 40, 6, 100, 1, '2022-11-03 10:00:15', '2022-11-03 10:00:15', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (60, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-10', 1, 27, 10, 100, 1, '2022-11-03 10:00:29', '2022-11-03 10:00:29', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (61, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-11', 0, 33, 22, 100, 1, '2022-11-03 10:00:44', '2022-11-03 10:00:44', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (62, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-11', 0, 40, 6, 100, 1, '2022-11-03 10:00:59', '2022-11-03 10:00:59', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (63, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-11', 1, 27, 10, 100, 1, '2022-11-03 10:01:09', '2022-11-03 10:01:09', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (64, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-12', 0, 33, 22, 100, 1, '2022-11-03 10:01:15', '2022-11-03 10:01:15', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (65, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-12', 0, 40, 6, 100, 1, '2022-11-03 10:01:25', '2022-11-03 10:01:25', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (66, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-12', 1, 27, 10, 100, 1, '2022-11-03 10:01:38', '2022-11-03 10:01:38', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (67, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-13', 0, 33, 22, 100, 1, '2022-11-03 10:01:49', '2022-11-03 10:01:49', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (68, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-13', 0, 40, 6, 100, 1, '2022-11-03 10:02:00', '2022-11-03 10:02:00', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (69, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-13', 1, 27, 10, 100, 1, '2022-11-03 10:02:10', '2022-11-03 10:02:10', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (70, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-14', 0, 33, 22, 100, 1, '2022-11-03 10:02:20', '2022-11-03 10:02:20', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (71, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-14', 0, 40, 6, 100, 1, '2022-11-03 10:02:27', '2022-11-03 10:02:27', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (72, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-14', 1, 27, 10, 100, 1, '2022-11-03 10:02:33', '2022-11-03 10:02:33', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (73, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-15', 0, 33, 22, 100, 1, '2022-11-03 10:02:38', '2022-11-03 10:02:38', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (74, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-15', 0, 40, 6, 100, 1, '2022-11-03 10:02:45', '2022-11-03 10:02:45', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (75, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-15', 1, 27, 10, 100, 1, '2022-11-03 10:02:51', '2022-11-03 10:02:51', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (76, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-16', 0, 33, 22, 100, 1, '2022-11-03 10:02:58', '2022-11-03 10:02:58', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (77, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-16', 0, 40, 6, 100, 1, '2022-11-03 10:03:04', '2022-11-03 10:03:04', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (78, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-16', 1, 27, 10, 100, 1, '2022-11-03 10:03:10', '2022-11-03 10:03:10', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (79, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-17', 0, 33, 22, 100, 1, '2022-11-03 10:03:16', '2022-11-03 10:03:16', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (80, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-17', 0, 40, 6, 100, 1, '2022-11-03 10:03:23', '2022-11-03 10:03:23', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (81, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-17', 1, 27, 10, 100, 1, '2022-11-03 10:03:33', '2022-11-03 10:03:33', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (82, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-18', 0, 33, 22, 100, 1, '2022-11-03 10:03:42', '2022-11-03 10:03:42', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (83, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-18', 0, 40, 6, 100, 1, '2022-11-03 10:03:50', '2022-11-03 10:03:50', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (84, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-18', 1, 27, 10, 100, 1, '2022-11-03 10:04:01', '2022-11-03 10:04:01', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (85, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-19', 0, 33, 22, 100, 1, '2022-11-03 10:04:07', '2022-11-03 10:04:07', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (86, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-19', 0, 40, 6, 100, 1, '2022-11-03 10:04:14', '2022-11-03 10:04:14', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (87, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-19', 1, 27, 10, 100, 1, '2022-11-03 10:04:21', '2022-11-03 10:04:21', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (88, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-20', 0, 33, 22, 100, 1, '2022-11-03 10:04:27', '2022-11-03 10:04:27', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (89, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-20', 0, 40, 6, 100, 1, '2022-11-03 10:04:34', '2022-11-03 10:04:34', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (90, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-20', 1, 27, 10, 100, 1, '2022-11-03 10:04:40', '2022-11-03 10:04:40', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (91, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-21', 0, 33, 22, 100, 1, '2022-11-03 10:04:44', '2022-11-03 10:04:44', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (92, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-21', 0, 40, 6, 100, 1, '2022-11-03 10:04:51', '2022-11-03 10:04:51', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (93, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-21', 1, 27, 10, 100, 1, '2022-11-03 10:05:07', '2022-11-03 10:05:07', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (94, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-22', 0, 33, 22, 100, 1, '2022-11-03 10:05:21', '2022-11-03 10:05:21', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (95, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-22', 0, 40, 6, 100, 1, '2022-11-03 10:05:28', '2022-11-03 10:05:28', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (96, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-22', 1, 27, 10, 100, 1, '2022-11-03 10:05:37', '2022-11-03 10:05:37', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (97, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-23', 0, 33, 22, 100, 1, '2022-11-03 10:05:51', '2022-11-03 10:05:51', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (98, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-23', 0, 40, 6, 100, 1, '2022-11-03 10:06:02', '2022-11-03 10:06:02', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (99, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-23', 1, 27, 10, 100, 1, '2022-11-03 10:06:06', '2022-11-03 10:06:06', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (100, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-24', 0, 33, 22, 100, 1, '2022-11-03 10:06:14', '2022-11-03 10:06:14', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (101, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-24', 0, 40, 6, 100, 1, '2022-11-03 10:06:24', '2022-11-03 10:06:24', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (102, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-24', 1, 27, 10, 100, 1, '2022-11-03 10:06:30', '2022-11-03 10:06:30', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (103, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-25', 0, 33, 22, 100, 1, '2022-11-03 10:06:36', '2022-11-03 10:06:36', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (104, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-25', 0, 40, 6, 100, 1, '2022-11-03 10:06:38', '2022-11-03 10:06:38', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (105, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-25', 1, 27, 10, 100, 1, '2022-11-03 10:06:42', '2022-11-03 10:06:42', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (106, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-26', 0, 33, 22, 100, 1, '2022-11-03 10:06:47', '2022-11-03 10:06:47', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (107, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-26', 0, 40, 6, 100, 1, '2022-11-03 10:06:54', '2022-11-03 10:06:54', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (108, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-26', 1, 27, 10, 100, 1, '2022-11-03 10:07:09', '2022-11-03 10:07:09', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (109, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-27', 0, 33, 22, 100, 1, '2022-11-03 10:07:22', '2022-11-03 10:07:22', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (110, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-27', 0, 40, 6, 100, 1, '2022-11-03 10:07:32', '2022-11-03 10:07:32', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (111, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-27', 1, 27, 10, 100, 1, '2022-11-03 10:07:41', '2022-11-03 10:07:41', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (112, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-28', 0, 33, 22, 100, 1, '2022-11-03 10:07:47', '2022-11-03 10:07:47', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (113, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-28', 0, 40, 6, 100, 1, '2022-11-03 10:07:53', '2022-11-03 10:07:53', 0);
INSERT INTO `schedule` (`id`, `hoscode`, `depcode`, `title`, `docname`, `skill`, `work_date`, `work_time`, `reserved_number`, `available_number`, `amount`, `status`, `create_time`, `update_time`, `is_deleted`) VALUES (114, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-28', 1, 27, 10, 100, 1, '2022-11-03 10:07:59', '2022-11-03 10:07:59', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
